Tabela BudgetCycleValue

Definicja tabeli BudgetCycleValue

Name

BudgetCycleValue

Code

BudgetCycleValue

Comment

Wartosci cykli budzetowych


Lista kolumn tabeli BudgetCycleValue

Name

Code

BudgetCycleValueID

BudgetCycleValueID

BudgetCycleID

BudgetCycleID

BudgetStructureElementID

BudgetStructureElementID

ResponsibilityCenterID

ResponsibilityCenterID

BudgetVariableID

BudgetVariableID

TimeAxisID

TimeAxisID

Value

Value

Calculated

Calculated


Kolumna BudgetCycleValueID tabeli BudgetCycleValue

Definicja kolumny BudgetCycleValueID tabeli BudgetCycleValue

Name

BudgetCycleValueID

Code

BudgetCycleValueID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID wartosci


Kolumna BudgetCycleID tabeli BudgetCycleValue

Definicja kolumny BudgetCycleID tabeli BudgetCycleValue

Name

BudgetCycleID

Code

BudgetCycleID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID cyklu budzetowego


Kolumna BudgetStructureElementID tabeli BudgetCycleValue

Definicja kolumny BudgetStructureElementID tabeli BudgetCycleValue

Name

BudgetStructureElementID

Code

BudgetStructureElementID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID elementu struktury budzetu


Kolumna ResponsibilityCenterID tabeli BudgetCycleValue

Definicja kolumny ResponsibilityCenterID tabeli BudgetCycleValue

Name

ResponsibilityCenterID

Code

ResponsibilityCenterID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID osrodka odpowiedzialnosci


Kolumna BudgetVariableID tabeli BudgetCycleValue

Definicja kolumny BudgetVariableID tabeli BudgetCycleValue

Name

BudgetVariableID

Code

BudgetVariableID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID zmiennej budzetowej


Kolumna TimeAxisID tabeli BudgetCycleValue

Definicja kolumny TimeAxisID tabeli BudgetCycleValue

Name

TimeAxisID

Code

TimeAxisID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID okresu


Kolumna Value tabeli BudgetCycleValue

Definicja kolumny Value tabeli BudgetCycleValue

Name

Value

Code

Value

Data Type

NUMBER(19,4)

Mandatory

No

Comment

Wartosc


Kolumna Calculated tabeli BudgetCycleValue

Definicja kolumny Calculated tabeli BudgetCycleValue

Name

Calculated

Code

Calculated

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Flaga informujaca czy wartosc zostala wyliczona czy wprowadzona recznie


Lista kluczy tabeli BudgetCycleValue

Name

Code

Primary

PK_BUDGETCYCLEVALUE

PK_BUDGETCYCLEVALUE

X


Klucz PK_BUDGETCYCLEVALUE tabeli BudgetCycleValue

Definicja klucza PK_BUDGETCYCLEVALUE tabeli BudgetCycleValue

Name

PK_BUDGETCYCLEVALUE

Code

PK_BUDGETCYCLEVALUE

Primary

Yes

Comment